class DataCountry < ActiveRecord::Migration
  def self.up
  	# Vidage préalable de la table 
  	down  
  	# Création des pays
    Country.create (:name => 'Afghanistan', :abbreviation => 'af', :continent_id => '3')
  	Country.create (:name => 'Afrique du Sud', :abbreviation => 'za', :continent_id => '2')
  	Country.create (:name => 'Albanie', :abbreviation => 'al', :continent_id => '1')
  	Country.create (:name => 'Algerie', :abbreviation => 'dz', :continent_id => '2')
  	Country.create (:name => 'Allemagne', :abbreviation => 'de', :continent_id => '1')
  	Country.create (:name => 'Andorre', :abbreviation => 'ad', :continent_id => '1')
  	Country.create (:name => 'Angola', :abbreviation => 'ao', :continent_id => '2')
  	Country.create (:name => 'Antigua-et-Barbuda', :abbreviation => 'ag', :continent_id => '5')
  	Country.create (:name => 'Arabie saoudite', :abbreviation => 'sa', :continent_id => '3')
  	Country.create (:name => 'Argentine', :abbreviation => 'ar', :continent_id => '6')
  	Country.create (:name => 'Armenie', :abbreviation => 'am', :continent_id => '1')
  	Country.create (:name => 'Australie', :abbreviation => 'au', :continent_id => '4')
  	Country.create (:name => 'Autriche', :abbreviation => 'at', :continent_id => '1')
  	Country.create (:name => 'Azerbaidjan', :abbreviation => 'az', :continent_id => '1')
  	Country.create (:name => 'Bahamas', :abbreviation => 'bs', :continent_id => '5')
  	Country.create (:name => 'Bahrein', :abbreviation => 'bh', :continent_id => '3')
  	Country.create (:name => 'Bangladesh', :abbreviation => 'bd', :continent_id => '3')
  	Country.create (:name => 'Barbade', :abbreviation => 'bb', :continent_id => '5')
  	Country.create (:name => 'Belgique', :abbreviation => 'be', :continent_id => '1')
  	Country.create (:name => 'Belize', :abbreviation => 'bz', :continent_id => '5')
  	Country.create (:name => 'Benin', :abbreviation => 'bj', :continent_id => '2')
  	Country.create (:name => 'Bhoutan', :abbreviation => 'bt', :continent_id => '3')
  	Country.create (:name => 'Bielorussie', :abbreviation => 'by', :continent_id => '1')
  	Country.create (:name => 'Birmanie', :abbreviation => 'mm', :continent_id => '3')
  	Country.create (:name => 'Bolivie', :abbreviation => 'bo', :continent_id => '6')
  	Country.create (:name => 'Bosnie-Herzegovine', :abbreviation => 'ba', :continent_id => '1')
  	Country.create (:name => 'Botswana', :abbreviation => 'bw', :continent_id => '2')
  	Country.create (:name => 'Bresil', :abbreviation => 'br', :continent_id => '6')
  	Country.create (:name => 'Brunei', :abbreviation => 'bn', :continent_id => '3')
  	Country.create (:name => 'Bulgarie', :abbreviation => 'bg', :continent_id => '1')
  	Country.create (:name => 'Burkina Faso', :abbreviation => 'bf', :continent_id => '2')
  	Country.create (:name => 'Burundi', :abbreviation => 'bi', :continent_id => '2')
  	Country.create (:name => 'Cameroun', :abbreviation => 'cm', :continent_id => '2')
  	Country.create (:name => 'Canada', :abbreviation => 'ca', :continent_id => '5')
  	Country.create (:name => 'Cap-Vert', :abbreviation => 'cv', :continent_id => '2')
  	Country.create (:name => 'Chili', :abbreviation => 'cl', :continent_id => '6')
  	Country.create (:name => 'Chine', :abbreviation => 'cn', :continent_id => '3')
  	Country.create (:name => 'Chypre', :abbreviation => 'cy', :continent_id => '1')
  	Country.create (:name => 'Colombie', :abbreviation => 'co', :continent_id => '6')
  	Country.create (:name => 'Congo', :abbreviation => 'cd', :continent_id => '2')
  	Country.create (:name => 'Coree du Nord', :abbreviation => 'kp', :continent_id => '3')
  	Country.create (:name => 'Coree du Sud', :abbreviation => 'kr', :continent_id => '3')
  	Country.create (:name => 'Costa Rica', :abbreviation => 'cr', :continent_id => '5')
  	Country.create (:name => 'Cote d Ivoire', :abbreviation => 'ci', :continent_id => '2')
  	Country.create (:name => 'Croatie', :abbreviation => 'hr', :continent_id => '1')
  	Country.create (:name => 'Cuba', :abbreviation => 'cu', :continent_id => '5')
  	Country.create (:name => 'Danemark', :abbreviation => 'dk', :continent_id => '1')
  	Country.create (:name => 'Djibouti', :abbreviation => 'dj', :continent_id => '2')
  	Country.create (:name => 'Dominique', :abbreviation => 'dm', :continent_id => '5')
  	Country.create (:name => 'Ecosse', :abbreviation => 'ek', :continent_id => '1')
  	Country.create (:name => 'Egypte', :abbreviation => 'eg', :continent_id => '2')
  	Country.create (:name => 'Emirats arabes unis', :abbreviation => 'ae', :continent_id => '3')
  	Country.create (:name => 'Angleterre', :abbreviation => 'en', :continent_id => '1')
  	Country.create (:name => 'Equateur', :abbreviation => 'ec', :continent_id => '6')
  	Country.create (:name => 'Erythree', :abbreviation => 'er', :continent_id => '2')
  	Country.create (:name => 'Espagne', :abbreviation => 'es', :continent_id => '1')
  	Country.create (:name => 'Estonie', :abbreviation => 'ee', :continent_id => '1')
  	Country.create (:name => 'Etats-Unis', :abbreviation => 'us', :continent_id => '5')
  	Country.create (:name => 'Ethiopie', :abbreviation => 'et', :continent_id => '2')
  	Country.create (:name => 'Ex-Republique yougoslave de Macedoine', :abbreviation => 'mk', :continent_id => '1')
  	Country.create (:name => 'Finlande', :abbreviation => 'fi', :continent_id => '1')
  	Country.create (:name => 'France', :abbreviation => 'fr', :continent_id => '1')
  	Country.create (:name => 'Gabon', :abbreviation => 'ga', :continent_id => '2')
  	Country.create (:name => 'Georgie', :abbreviation => 'gr', :continent_id => '1')
  	Country.create (:name => 'Ghana', :abbreviation => 'gh', :continent_id => '2')
  	Country.create (:name => 'Grece', :abbreviation => 'gr', :continent_id => '1')
  	Country.create (:name => 'Guatemala', :abbreviation => 'gt', :continent_id => '5')
  	Country.create (:name => 'Guinee', :abbreviation => 'gn', :continent_id => '2')
  	Country.create (:name => 'Guinee-Bissao', :abbreviation => 'gw', :continent_id => '2')
  	Country.create (:name => 'Guinee Equatoriale', :abbreviation => 'gq', :continent_id => '2')
  	Country.create (:name => 'Guyana', :abbreviation => 'gy', :continent_id => '6')
  	Country.create (:name => 'Haiti', :abbreviation => 'ht', :continent_id => '5')
  	Country.create (:name => 'Honduras', :abbreviation => 'hn', :continent_id => '5')
  	Country.create (:name => 'Hongrie', :abbreviation => 'hu', :continent_id => '1')
  	Country.create (:name => 'Iles Feroe', :abbreviation => 'fo', :continent_id => '1')
  	Country.create (:name => 'Iles Fidji', :abbreviation => 'fj', :continent_id => '4')
  	Country.create (:name => 'Iles Marshall', :abbreviation => 'mh', :continent_id => '4')
  	Country.create (:name => 'Inde', :abbreviation => 'in', :continent_id => '3')
  	Country.create (:name => 'Indonesie', :abbreviation => 'id', :continent_id => '3')
  	Country.create (:name => 'Iran', :abbreviation => 'ir', :continent_id => '3')
  	Country.create (:name => 'Iraq', :abbreviation => 'iq', :continent_id => '3')
  	Country.create (:name => 'Irlande', :abbreviation => 'ie', :continent_id => '1')
  	Country.create (:name => 'Islande', :abbreviation => 'is', :continent_id => '1')
  	Country.create (:name => 'Israel', :abbreviation => 'il', :continent_id => '3')
  	Country.create (:name => 'Italie', :abbreviation => 'it', :continent_id => '1')
  	Country.create (:name => 'Jamaique', :abbreviation => 'jm', :continent_id => '5')
  	Country.create (:name => 'Japon', :abbreviation => 'jp', :continent_id => '3')
  	Country.create (:name => 'Jordanie', :abbreviation => 'jo', :continent_id => '3')
  	Country.create (:name => 'Kazakhstan', :abbreviation => 'kz', :continent_id => '3')
  	Country.create (:name => 'Kenya', :abbreviation => 'ke', :continent_id => '2')
  	Country.create (:name => 'Kirghizistan', :abbreviation => 'kg', :continent_id => '3')
  	Country.create (:name => 'Kiribati', :abbreviation => 'ki', :continent_id => '4')
  	Country.create (:name => 'Koweit', :abbreviation => 'kw', :continent_id => '3')
  	Country.create (:name => 'Laos', :abbreviation => 'la', :continent_id => '3')
  	Country.create (:name => 'Lettonie', :abbreviation => 'lv', :continent_id => '1')
  	Country.create (:name => 'Liban', :abbreviation => 'lb', :continent_id => '3')
  	Country.create (:name => 'Liberia', :abbreviation => 'lr', :continent_id => '2')
  	Country.create (:name => 'Libye', :abbreviation => 'ly', :continent_id => '2')
  	Country.create (:name => 'Liechtenstein', :abbreviation => 'li', :continent_id => '1')
  	Country.create (:name => 'Lituanie', :abbreviation => 'lt', :continent_id => '1')
  	Country.create (:name => 'Luxembourg', :abbreviation => 'lu', :continent_id => '1')
  	Country.create (:name => 'Madagascar', :abbreviation => 'mg', :continent_id => '2')
  	Country.create (:name => 'Malaisie', :abbreviation => 'my', :continent_id => '3')
  	Country.create (:name => 'Malawi', :abbreviation => 'mw', :continent_id => '2')
  	Country.create (:name => 'Maldives', :abbreviation => 'mv', :continent_id => '3')
  	Country.create (:name => 'Mali', :abbreviation => 'ml', :continent_id => '2')
  	Country.create (:name => 'Malte', :abbreviation => 'mt', :continent_id => '1')
  	Country.create (:name => 'Maroc', :abbreviation => 'ma', :continent_id => '2')
  	Country.create (:name => 'Maurice', :abbreviation => 'mu', :continent_id => '2')
  	Country.create (:name => 'Mauritanie', :abbreviation => 'mr', :continent_id => '2')
  	Country.create (:name => 'Mexique', :abbreviation => 'mx', :continent_id => '5')
  	Country.create (:name => 'Moldavie', :abbreviation => 'md', :continent_id => '1')
  	Country.create (:name => 'Monaco', :abbreviation => 'mc', :continent_id => '1')
  	Country.create (:name => 'Mongolie', :abbreviation => 'mn', :continent_id => '3')
  	Country.create (:name => 'Montenegro', :abbreviation => 'me', :continent_id => '1')
  	Country.create (:name => 'Mozambique', :abbreviation => 'mz', :continent_id => '2')
  	Country.create (:name => 'Namibie', :abbreviation => 'na', :continent_id => '2')
  	Country.create (:name => 'Nauru', :abbreviation => 'nr', :continent_id => '4')
  	Country.create (:name => 'Nepal', :abbreviation => 'np', :continent_id => '3')
  	Country.create (:name => 'Nicaragua', :abbreviation => 'ni', :continent_id => '5')
  	Country.create (:name => 'Niger', :abbreviation => 'ne', :continent_id => '2')
  	Country.create (:name => 'Nigeria', :abbreviation => 'ng', :continent_id => '2')
  	Country.create (:name => 'Norvege', :abbreviation => 'no', :continent_id => '1')
  	Country.create (:name => 'Nouvelle-Zelande', :abbreviation => 'nz', :continent_id => '4')
  	Country.create (:name => 'Oman', :abbreviation => 'om', :continent_id => '3')
  	Country.create (:name => 'Pakistan', :abbreviation => 'pk', :continent_id => '3')
  	Country.create (:name => 'Panama', :abbreviation => 'pa', :continent_id => '5')
  	Country.create (:name => 'Papouasie-Nouvelle-Guinee', :abbreviation => 'pg', :continent_id => '4')
  	Country.create (:name => 'Paraguay', :abbreviation => 'py', :continent_id => '6')
  	Country.create (:name => 'Pays-Bas', :abbreviation => 'nl', :continent_id => '1')
  	Country.create (:name => 'Perou', :abbreviation => 'pe', :continent_id => '6')
  	Country.create (:name => 'Philippines', :abbreviation => 'ph', :continent_id => '3')
  	Country.create (:name => 'Pologne', :abbreviation => 'pl', :continent_id => '1')
  	Country.create (:name => 'Porto Rico', :abbreviation => 'ch', :continent_id => '5')
  	Country.create (:name => 'Portugal', :abbreviation => 'pt', :continent_id => '1')
  	Country.create (:name => 'Qatar', :abbreviation => 'qa', :continent_id => '3')
  	Country.create (:name => 'Republique democratique du Congo', :abbreviation => 'cg', :continent_id => '2')
  	Country.create (:name => 'Republique dominicaine', :abbreviation => 'do', :continent_id => '5')
  	Country.create (:name => 'Republique d Irlande du nord', :abbreviation => 'ii', :continent_id => '1')
  	Country.create (:name => 'Republique tcheque', :abbreviation => 'cz', :continent_id => '1')
  	Country.create (:name => 'Roumanie', :abbreviation => 'ro', :continent_id => '1')
  	Country.create (:name => 'Royaume-Uni', :abbreviation => 'gb', :continent_id => '1')
  	Country.create (:name => 'Russie', :abbreviation => 'ru', :continent_id => '1')
  	Country.create (:name => 'Rwanda', :abbreviation => 'rw', :continent_id => '2')
  	Country.create (:name => 'Saint-Marin', :abbreviation => 'sm', :continent_id => '1')
  	Country.create (:name => 'Salvador', :abbreviation => 'sv', :continent_id => '5')
  	Country.create (:name => 'Sao Tome-et-Principe', :abbreviation => 'st', :continent_id => '2')
  	Country.create (:name => 'Senegal', :abbreviation => 'sn', :continent_id => '2')
  	Country.create (:name => 'Serbie', :abbreviation => 'rs', :continent_id => '1')
  	Country.create (:name => 'Seychelles', :abbreviation => 'sc', :continent_id => '2')
  	Country.create (:name => 'Sierra Leone', :abbreviation => 'sl', :continent_id => '2')
  	Country.create (:name => 'Singapour', :abbreviation => 'sg', :continent_id => '3')
  	Country.create (:name => 'Slovaquie', :abbreviation => 'sk', :continent_id => '1')
  	Country.create (:name => 'Slovenie', :abbreviation => 'si', :continent_id => '1')
  	Country.create (:name => 'Somalie', :abbreviation => 'so', :continent_id => '2')
  	Country.create (:name => 'Soudan', :abbreviation => 'sd', :continent_id => '2')
  	Country.create (:name => 'Sri Lanka', :abbreviation => 'lk', :continent_id => '3')
  	Country.create (:name => 'Suede', :abbreviation => 'se', :continent_id => '1')
  	Country.create (:name => 'Suisse', :abbreviation => 'ch', :continent_id => '1')
  	Country.create (:name => 'Swaziland', :abbreviation => 'sz', :continent_id => '2')
  	Country.create (:name => 'Syrie', :abbreviation => 'sy', :continent_id => '3')
  	Country.create (:name => 'Tadjikistan', :abbreviation => 'tj', :continent_id => '3')
  	Country.create (:name => 'Tanzanie', :abbreviation => 'tz', :continent_id => '2')
  	Country.create (:name => 'Tchad', :abbreviation => 'td', :continent_id => '2')
  	Country.create (:name => 'Thailande', :abbreviation => 'th', :continent_id => '3')
  	Country.create (:name => 'Timor Oriental', :abbreviation => 'tl', :continent_id => '3')
  	Country.create (:name => 'Togo', :abbreviation => 'tg', :continent_id => '2')
  	Country.create (:name => 'Tonga', :abbreviation => 'to', :continent_id => '4')
  	Country.create (:name => 'Trinite-et-Tobago', :abbreviation => 'tt', :continent_id => '5')
  	Country.create (:name => 'Tunisie', :abbreviation => 'tn', :continent_id => '2')
  	Country.create (:name => 'Turkmenistan', :abbreviation => 'tm', :continent_id => '3')
  	Country.create (:name => 'Turquie', :abbreviation => 'tr', :continent_id => '1')
  	Country.create (:name => 'Tuvalu', :abbreviation => 'tv', :continent_id => '4')
  	Country.create (:name => 'Ukraine', :abbreviation => 'ua', :continent_id => '1')
  	Country.create (:name => 'Uruguay', :abbreviation => 'uy', :continent_id => '6')
  	Country.create (:name => 'Vanuatu', :abbreviation => 'vu', :continent_id => '4')
  	Country.create (:name => 'Venezuela', :abbreviation => 've', :continent_id => '6')
  	Country.create (:name => 'Viet Nam', :abbreviation => 'vn', :continent_id => '3')
  	Country.create (:name => 'Yemen', :abbreviation => 'ye', :continent_id => '3')
  	Country.create (:name => 'Zambie', :abbreviation => 'zm', :continent_id => '2')
  	Country.create (:name => 'Zimbabwe', :abbreviation => 'zw', :continent_id => '2') 
  end

  def self.down
  	# Vidage de la table
  	Country.delete_all 
  end
end